Name |
|
Code |
|
Comment |
Elementy zamówien wewnetrznych |
Name |
Code |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
Yes |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
id jednostki wybranej / prezentowanej uzytkownikowi przy pozycji |
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
Data podania |
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
No |
Comment |
Flaga niezamienialnosci leku |
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
Alias leku |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
ID zasobu ze zlecenia zewnetrznego |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
ID pacjenta |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
ID lekarza |
Name |
|
Code |
|
Data Type |
NUMBER(19,8) |
Mandatory |
No |
Comment |
Ilosc |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
Liczba porzadkowa |
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
Zamawiana ilosc slownie. Dotyczy narkotyków i psychotropów. |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
Kolumna ID drogi podania leku |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
ID zewnetrznego zasobu ze zlecenia |
Name |
|
Code |
|
Data Type |
VARCHAR2(4000) |
Mandatory |
No |
Comment |
Przyczyna anulowania zamówienia |
Name |
|
Code |
|
Data Type |
NUMBER(19,8) |
Mandatory |
No |
Comment |
Cena z umowy w pozycji zamówienia |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
Zrodlo finansowania |
Name |
|
Code |
|
Data Type |
VARCHAR2(50) |
Mandatory |
No |
Comment |
Numer zlecenia z systemu zewnetrznego |
Name |
Code |
Primary |
X |
Name |
|
Code |
|
Primary |
Yes |
Comment |
|
|
|
|